Syntax | Description | Example |
---|---|---|
BITAND(n1[, n2,... nN]) | Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in all numbers are 1. Otherwise, the bit is set to 0. | BITAND(7,2) Returns: 2 (7 = 0111, 2 = 0010) |
BITNOT(nNumber) | Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bit in number is 0. Otherwise, the bit is set to 0. | BITNOT(1) Returns: 2 ^ 32 - 1 |
BITOR(n1[, n2,... nN]) | Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in at least one numbers is 1. Otherwise, the bit is set to 0. | BITOR(5,3) Returns: 7 (5 = 0101, 3 = 0011, 7 = 0111) |
BITXOR(n1[, n2,... nN]) | Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in bn1 AND bn2 are different. Otherwise, the bit is set to 0. | BITXOR(5,3) Returns: 6 (5 = 0101, 3 = 0011, 6 = 0110) |